Problem Note 60473: Incorrect numbers for side-by-side joins occur when the number of market states is different between the two subcubes in the join
When you use SAS® High-Performance Risk to perform side-by-side joins and the number of market states is different between the two subcubes, the joined cube results do not match. This issue occurs when joins use the following types of subcubes:
- Created from PRICEBY=POSITIONS
- Created from PRICEBY=STATES
- Resulting from the use of the GET_STATISTIC function or from the use of the GET_RANKED_VALUES or GET_RANKED_VALUES_TOP CALL routine in a user-defined statistic
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | SAS High-Performance Risk | Microsoft® Windows® for x64 | 3.7 | 3.8 | 9.4 TS1M4 | 9.4 TS1M4 |
| 64-bit Enabled AIX | 3.7 | 3.8 | 9.4 TS1M4 | 9.4 TS1M4 |
| 64-bit Enabled Solaris | 3.7 | 3.8 | 9.4 TS1M4 | 9.4 TS1M4 |
| Linux for x64 | 3.7 | 3.8 | 9.4 TS1M4 | 9.4 TS1M4 |
| Solaris for x64 | 3.7 | 3.8 | 9.4 TS1M4 | 9.4 TS1M4 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
When using SAS® High-Performance Risk to perform side-by-side joins and the number of market states are different between the two subcubes, the joined cube results do not match.
| Type: | Problem Note |
| Priority: | high |
| Topic: | Analytics ==> Financial Analysis
|
| Date Modified: | 2017-05-18 13:47:03 |
| Date Created: | 2017-05-16 14:40:22 |
